<?php
 /*********************************************\
 |* @author Yannic Schnetz, Mike Waldvogel    *|
 |* @copyright Yannic Schnetz, Mike Waldvogel *|
 |*********************************************|
 |* @since 30.07.2013                         *|
 \*********************************************/

$prices = array();
$pquery = $DB->query("SELECT * FROM `preise` WHERE `gruppen_id` = '" . Group::get_groupid_by_name('zimmer') . "'");
while($row = $DB->fetch($pquery)) {
    $row['preis'] = str_replace('.', ',', $row['preis']);
    $prices[] = $row;
}

$addings = array();
$aquery = $DB->query("SELECT * FROM `preise` WHERE `gruppen_id` = '" . Group::get_groupid_by_name('zuschlaege') . "'");
while($row = $DB->fetch($aquery)) {
    $row['preis'] = str_replace('.', ',', $row['preis']);
    $addings[] = $row;
}

$f = $DB->fetch("SELECT `preise`, `konus` FROM `texts` LIMIT 1");

$tpl->assign('prices', $prices);
$tpl->assign('preistext', Functions::defilter_text($f['preise']));
$tpl->assign('konustext', Functions::defilter_text($f['konus']));
$tpl->assign('addings', $addings);
?>
